Create and Use Databases: Microsoft Access 2013 by Tilde Publishing

Author:Tilde Publishing [Publishing, Tilde]
Language: eng
Format: mobi
Tags: Getting started, Generating reports., Adjusting form layout, Creating databse tables, creating and working with forms, Using database objects and exploring tables, Designing your database, Querying your database
ISBN: 9780734608567
Publisher: Tilde
Published: 2017-03-19T04:00:00+00:00

Return to Design View. Note the quotation marks and hash characters automatically added around the selection criteria.

Save, using the Query Name: 2 Bed Units Booked from 13 June 2013.

Close your query.

Next, you create a query that shows the bookings for all Standard units.

Display the Create ribbon, then click on the Query Design button

(Queries group). The Show Table dialogue box is presented.

Double click on Unit details..

Double click on Booking details, then click on Close.

Add the following fields in order to the query design grid:

Unit number (Unit details table), Unit type, Date in, Date out.

Click on the Criteria row under the Unit type field, then type:

Standard

Display the query in Datasheet View.

How many bookings are there for Standard Units?

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.